home *** CD-ROM | disk | FTP | other *** search
- UPDATE UpdateList
- SET action = "D"
- WHERE EXISTS (SELECT *
- FROM UpdateList Upd1, UpdateList Upd2
- WHERE (Upd1.action = "B")
- AND (Upd2.action = "C")
- AND (Upd1.reg# = Upd2.reg#)
- AND (Upd1.outlet# = Upd2.outlet#))
- AND (action = "B");
-
- UPDATE UpdateList
- SET action = "A"
- WHERE EXISTS (SELECT *
- FROM UpdateList Upd1, UpdateList Upd2
- WHERE (Upd1.action = "B")
- AND (Upd2.action = "C")
- AND (Upd1.reg# = Upd2.reg#)
- AND (Upd1.outlet# = Upd2.outlet#))
- AND (action = "C");
-
-